There are many interfaces in the current project, the data source may be different database or different users of the table, to access the table caused a certain amount of trouble. This time you can use synonyms to simplify.
The syntax for synonyms
Guide: SynonymIt is an alias for database solution objects and is often used to simplify object access and improve object access security. When using synonyms,Oracle DatabaseTranslate it into the name of the corresponding solution object. Similar to
Oracle 's synonym (synonyms) is literally understood as the meaning of an alias, similar to the function of an attempt, a mapping relationship. This article describes how to create synonym statements, delete synonyms, and view synonym statements.
I all Bovenchin hand code, give a concern or praise it! Blogger: Zhang qq:1445696451 Welcome to add Q to discuss technology at any time.I. Sequence of Oracle• A sequence is a database object used to generate a unique contiguous integer. A sequence
Concept
A graphical synonym is a representation of an object (table), which itself has no specific definition.
By graphically using synonyms, it is possible to use this object (table) in different places in the same physical diagram
Oracle _ sequence, index, synonym, oracle SynonymZookeeper
1. Sequence1. sequence: database objects that can be used by multiple users to generate unique valuesUnique value automatically providedShared objectIt is mainly used to provide the primary
Take a list of process business information to illustrate the use of Oracle synonym solutions.The following objects are available in the Oracle database Bpm_sun User:
Object Name
type
Description
Oracle Database provides the synonym management function. Synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security.
Oracle Database provides the synonym management function.
views Viewis a virtual table that does not store data values.Create or Replace View Patient Basic Information as Select from patient information table;When a view is created, only the definition of the view is stored in the database dictionary,
Pre-recordThis article simply explains how to use the N-gram model combined with Chinese pinyin to make error correction in Chinese, and then introduces the application of the shortest editing distance in Chinese search error correction; Finally,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.